/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : SQL Server
 Source Server Version : 14001000
 Source Catalog        : App
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 14001000
 File Encoding         : 65001

 Date: 11/02/2020 18:08:21
*/


-- ----------------------------
-- Table structure for wzy_edu_taobaoshop
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[wzy_edu_taobaoshop]') AND type IN ('U'))
	DROP TABLE [dbo].[wzy_edu_taobaoshop]
GO

CREATE TABLE [dbo].[wzy_edu_taobaoshop] (
  [shopname] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [price] real  NULL,
  [buydate] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [fahuo] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [shouhuo] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [id] int  IDENTITY(1,1) NOT NULL
)
GO

ALTER TABLE [dbo].[wzy_edu_taobaoshop] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of [wzy_edu_taobaoshop]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[wzy_edu_taobaoshop] ON
GO

INSERT INTO [dbo].[wzy_edu_taobaoshop] ([shopname], [price], [buydate], [fahuo], [shouhuo], [id]) VALUES (N'洗衣液', N'0.0100000', N'2020-02-11 00:00:00', N'否', N'否', N'2')
GO

INSERT INTO [dbo].[wzy_edu_taobaoshop] ([shopname], [price], [buydate], [fahuo], [shouhuo], [id]) VALUES (N'52度白酒', N'20.2600002', N'2020-02-11 00:00:00', N'是', N'否', N'3')
GO

INSERT INTO [dbo].[wzy_edu_taobaoshop] ([shopname], [price], [buydate], [fahuo], [shouhuo], [id]) VALUES (N'鱼食', N'28.4099998', N'2020-02-04 00:00:00', N'否', N'否', N'4')
GO

INSERT INTO [dbo].[wzy_edu_taobaoshop] ([shopname], [price], [buydate], [fahuo], [shouhuo], [id]) VALUES (N'鸡饲料', N'192.0399933', N'2020-02-11 15:26:39', N'否', N'否', N'5')
GO

INSERT INTO [dbo].[wzy_edu_taobaoshop] ([shopname], [price], [buydate], [fahuo], [shouhuo], [id]) VALUES (N'小麦', N'33.9900017', N'2020-02-11 15:26:55', N'否', N'否', N'6')
GO

INSERT INTO [dbo].[wzy_edu_taobaoshop] ([shopname], [price], [buydate], [fahuo], [shouhuo], [id]) VALUES (N'牙膏', N'8.8100004', N'2020-02-11 15:27:27', N'否', N'否', N'7')
GO

INSERT INTO [dbo].[wzy_edu_taobaoshop] ([shopname], [price], [buydate], [fahuo], [shouhuo], [id]) VALUES (N'导水器', N'8.0100002', N'2020-02-11 15:27:39', N'否', N'否', N'8')
GO

INSERT INTO [dbo].[wzy_edu_taobaoshop] ([shopname], [price], [buydate], [fahuo], [shouhuo], [id]) VALUES (N'活性炭', N'23.0000000', N'2020-02-11 00:00:00', N'是', N'否', N'9')
GO

INSERT INTO [dbo].[wzy_edu_taobaoshop] ([shopname], [price], [buydate], [fahuo], [shouhuo], [id]) VALUES (N'无刷水泵', N'51.0000000', N'2020-02-11 15:28:06', N'否', N'否', N'10')
GO

SET IDENTITY_INSERT [dbo].[wzy_edu_taobaoshop] OFF
GO


-- ----------------------------
-- Primary Key structure for table wzy_edu_taobaoshop
-- ----------------------------
ALTER TABLE [dbo].[wzy_edu_taobaoshop] ADD CONSTRAINT [PK__wzy_edu___3213E83FF770A112] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO

